package com.pn.taikao.mapper;

import com.pn.taikao.entity.College;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface CollegeMapper {
    int insert(College college);

    int update(College college);

    int deleteById(@Param("id") Long id);

    College selectById(@Param("id") Long id);

    College selectByName(@Param("name") String name);

    List<College> selectAll();

    List<College> selectPage(@Param("name") String name,
                            @Param("offset") int offset,
                            @Param("limit") int limit);

    long count(@Param("name") String name);
}













